﻿<%@ Page Language="C#" MasterPageFile="~/education.master" AutoEventWireup="true" CodeFile="eduplanempl.aspx.cs" Inherits="Default9_4" Title="员工培训计划" %>

<%@ Register Assembly="Infragistics2.WebUI.UltraWebGrid.v7.3, Version=7.3.20073.38, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"
    Namespace="Infragistics.WebUI.UltraWebGrid" TagPrefix="igtbl" %>

<%@ Register Assembly="Infragistics2.WebUI.Misc.v7.3, Version=7.3.20073.38, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"
    Namespace="Infragistics.WebUI.Misc" TagPrefix="igmisc" %>
<asp:Content ID="Content1" ContentPlaceHolderID="EduContent" Runat="server">

<Template>
<TABLE style="WIDTH: 100%; HEIGHT: 100%"><TBODY><TR><TD align="center">
            请认真学习，祝你考试顺利通过！</TD></TR>
    <TR><TD align="left">
    <asp:LoginName ID="LoginName1" runat="server" />
    <asp:Label ID="Label1" runat="server" Text="必修课程："></asp:Label></TD></TR>
    <tr>
        <td align="left" valign="top">
            <igtbl:ultrawebgrid id="UltraWebGrid1" runat="server" width="100%" 
                DataSourceID="SqlDataSource1" style="left: 4px; top: 17px" 
                DataKeyField="CourseID"><Bands>
<igtbl:UltraGridBand DataKeyField="CourseID">
<AddNewRow View="NotSet" Visible="NotSet"></AddNewRow>
    <Columns>
        <igtbl:TemplatedColumn>
            <CellTemplate>
                <asp:HyperLink ID="HyperLink2" runat="server" 
                    NavigateUrl="<%# GetNavigateUrlStuy(Container.DataItem) %>">进入学习</asp:HyperLink>
            </CellTemplate>
            <Header Caption="进入学习">
                <RowLayoutColumnInfo OriginX="1" />
            </Header>
            <Footer>
                <RowLayoutColumnInfo OriginX="1" />
            </Footer>
        </igtbl:TemplatedColumn>
        <igtbl:TemplatedColumn>
            <CellTemplate>
                <asp:HyperLink ID="HyperLink3" runat="server" 
                    NavigateUrl="<%# GetNavigateUrlExam(Container.DataItem) %>" 
                    Enabled="<%# GetEnabled(Container.DataItem,Container.DataItem,Container.DataItem) %>">进入考试</asp:HyperLink>
            </CellTemplate>
            <Header Caption="进入考试">
            </Header>
        </igtbl:TemplatedColumn>
        <igtbl:UltraGridColumn BaseColumnName="CourseID" DataType="System.Int32" 
            Hidden="True" IsBound="True" Key="CourseID">
            <Header Caption="CourseID">
                <RowLayoutColumnInfo OriginX="2" />
            </Header>
            <Footer>
                <RowLayoutColumnInfo OriginX="2" />
            </Footer>
        </igtbl:UltraGridColumn>
        <igtbl:UltraGridColumn BaseColumnName="课程名称" IsBound="True" Key="课程名称" 
            Width="300px">
            <Header Caption="课程名称">
                <RowLayoutColumnInfo OriginX="3" />
            </Header>
            <Footer>
                <RowLayoutColumnInfo OriginX="3" />
            </Footer>
        </igtbl:UltraGridColumn>
        <igtbl:UltraGridColumn BaseColumnName="考试状态" IsBound="True" Key="考试状态" 
            Width="100px">
            <Header Caption="考试状态">
                <RowLayoutColumnInfo OriginX="4" />
            </Header>
            <Footer>
                <RowLayoutColumnInfo OriginX="4" />
            </Footer>
        </igtbl:UltraGridColumn>
        <igtbl:UltraGridColumn BaseColumnName="最后一次考试日期" DataType="System.DateTime" 
            IsBound="True" Key="最后一次考试日期" Width="120px">
            <Header Caption="最后一次考试日期">
                <RowLayoutColumnInfo OriginX="5" />
            </Header>
            <Footer>
                <RowLayoutColumnInfo OriginX="5" />
            </Footer>
        </igtbl:UltraGridColumn>
        <igtbl:UltraGridColumn BaseColumnName="ExamNum" DataType="System.Int32" 
            Hidden="True" IsBound="True" Key="ExamNum">
            <Header Caption="ExamNum">
                <RowLayoutColumnInfo OriginX="6" />
            </Header>
            <Footer>
                <RowLayoutColumnInfo OriginX="6" />
            </Footer>
        </igtbl:UltraGridColumn>
    </Columns>
</igtbl:UltraGridBand>
</Bands>

<DisplayLayout Version="4.00" AllowSortingDefault="OnClient" StationaryMargins="Header" 
                    AllowColSizingDefault="NotSet" AllowUpdateDefault="Yes" 
                    StationaryMarginsOutlookGroupBy="True" HeaderClickActionDefault="SortMulti" 
                    Name="UltraWebGrid1" BorderCollapseDefault="Separate" AllowDeleteDefault="Yes" 
                    RowSelectorsDefault="No" TableLayout="Fixed" RowHeightDefault="20px" 
                    SelectTypeRowDefault="Extended" ColWidthDefault="90px">
<GroupByBox>
<BoxStyle BorderColor="Window" BackColor="ActiveBorder"></BoxStyle>
</GroupByBox>

<GroupByRowStyleDefault BorderColor="Window" BackColor="Control"></GroupByRowStyleDefault>

<ActivationObject BorderWidth="" BorderColor=""></ActivationObject>

<FooterStyleDefault BorderWidth="1px" BorderStyle="Solid" BackColor="LightGray">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</FooterStyleDefault>

<RowStyleDefault BorderWidth="1px" BorderColor="Silver" BorderStyle="Solid" Font-Size="8.25pt" Font-Names="Microsoft Sans Serif" BackColor="Window">
<BorderDetails ColorTop="Window" ColorLeft="Window"></BorderDetails>

<Padding Left="3px"></Padding>
</RowStyleDefault>

<FilterOptionsDefault>
<FilterOperandDropDownStyle BorderWidth="1px" BorderColor="Silver" BorderStyle="Solid" Font-Size="11px" Font-Names="Verdana,Arial,Helvetica,sans-serif" BackColor="White" CustomRules="overflow:auto;">
<Padding Left="2px"></Padding>
</FilterOperandDropDownStyle>

<FilterHighlightRowStyle ForeColor="White" BackColor="#151C55"></FilterHighlightRowStyle>

<FilterDropDownStyle BorderWidth="1px" BorderColor="Silver" BorderStyle="Solid" Font-Size="11px" Font-Names="Verdana,Arial,Helvetica,sans-serif" BackColor="White" Width="200px" Height="300px" CustomRules="overflow:auto;">
<Padding Left="2px"></Padding>
</FilterDropDownStyle>
</FilterOptionsDefault>

<HeaderStyleDefault HorizontalAlign="Left" BorderStyle="Solid" BackColor="LightGray" CustomRules="font-weight:normal;">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</HeaderStyleDefault>

<EditCellStyleDefault BorderWidth="0px" BorderStyle="None"></EditCellStyleDefault>

<FrameStyle BorderWidth="1px" BorderColor="InactiveCaption" Font-Size="8.25pt" 
        Font-Names="Microsoft Sans Serif" BackColor="Window" Width="100%"></FrameStyle>

<Pager MinimumPagesForDisplay="2" AllowPaging="True">
<PagerStyle BorderWidth="1px" BorderStyle="Solid" BackColor="LightGray">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</PagerStyle>
</Pager>

<AddNewBox Hidden="False">
<BoxStyle BorderWidth="1px" BorderColor="InactiveCaption" BorderStyle="Solid" BackColor="Window">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</BoxStyle>
</AddNewBox>
</DisplayLayout>
</igtbl:ultrawebgrid></td>
    </tr>
    <TR><TD>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:smsConnectionString %>"
                
                
                
                
                
                
                SelectCommand="SELECT StaffsInCourses.CourseID, CourseInfo.CourseName AS 课程名称, StaffsInCourses.ExamState AS 考试状态, Convert(char(10),StaffsInCourses.ExamDate,121) AS 最后一次考试日期, StaffsInCourses.ExamNum, CourseInfo.PassQuestionNum FROM CourseInfo INNER JOIN StaffsInCourses ON CourseInfo.CourseID = StaffsInCourses.CourseID INNER JOIN StaffInfo ON StaffsInCourses.StaffID = StaffInfo.StaffID WHERE (CourseInfo.IsDeleted &lt;&gt; 1) AND (StaffInfo.staffName = @staffName) AND (StaffsInCourses.IsElective = 1)">
                <SelectParameters>
                    <asp:ProfileParameter Name="staffName" PropertyName="StaffName" />
                </SelectParameters>
            </asp:SqlDataSource>
            </TD></TR>
    <TR><TD>
    <asp:LoginName ID="LoginName2" runat="server" />
    <asp:Label ID="Label2" runat="server" Text="选修课程："></asp:Label>
            </TD></TR>
    <TR><TD>
            <igtbl:ultrawebgrid id="UltraWebGrid2" runat="server" width="100%" 
                style="left: 4px; top: 17px" DataKeyField="CourseID"><Bands>
<igtbl:UltraGridBand DataKeyField="CourseID">
<AddNewRow View="NotSet" Visible="NotSet"></AddNewRow>
    <Columns>
        <igtbl:TemplatedColumn>
            <CellTemplate>
                <asp:HyperLink ID="HyperLink4" runat="server" 
                     NavigateUrl="<%# GetNavigateUrlStuy(Container.DataItem) %>">进入学习</asp:HyperLink>
            </CellTemplate>
            <Header Caption="进入学习">
                <RowLayoutColumnInfo OriginX="1" />
            </Header>
            <Footer>
                <RowLayoutColumnInfo OriginX="1" />
            </Footer>
        </igtbl:TemplatedColumn>
        <igtbl:TemplatedColumn>
            <CellTemplate>
                <asp:HyperLink ID="HyperLink5" runat="server" 
                 Enabled="<%# GetEnabled(Container.DataItem,Container.DataItem,Container.DataItem) %>" 
                    NavigateUrl="<%# GetNavigateUrlExam(Container.DataItem) %>">进入考试</asp:HyperLink>
            </CellTemplate>
            <Header Caption="进入考试">
<RowLayoutColumnInfo OriginX="1"></RowLayoutColumnInfo>
            </Header>

<Footer>
<RowLayoutColumnInfo OriginX="1"></RowLayoutColumnInfo>
</Footer>
        </igtbl:TemplatedColumn>
    </Columns>
</igtbl:UltraGridBand>
</Bands>

<DisplayLayout Version="4.00" AllowSortingDefault="OnClient" StationaryMargins="Header" 
                    AllowColSizingDefault="NotSet" AllowUpdateDefault="Yes" 
                    StationaryMarginsOutlookGroupBy="True" HeaderClickActionDefault="SortMulti" 
                    Name="UltraWebGrid1" BorderCollapseDefault="Separate" AllowDeleteDefault="Yes" 
                    RowSelectorsDefault="No" TableLayout="Fixed" RowHeightDefault="20px" 
                    SelectTypeRowDefault="Extended" ColWidthDefault="90px">
<GroupByBox>
<BoxStyle BorderColor="Window" BackColor="ActiveBorder"></BoxStyle>
</GroupByBox>

<GroupByRowStyleDefault BorderColor="Window" BackColor="Control"></GroupByRowStyleDefault>

<ActivationObject BorderWidth="" BorderColor=""></ActivationObject>

<FooterStyleDefault BorderWidth="1px" BorderStyle="Solid" BackColor="LightGray">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</FooterStyleDefault>

<RowStyleDefault BorderWidth="1px" BorderColor="Silver" BorderStyle="Solid" Font-Size="8.25pt" Font-Names="Microsoft Sans Serif" BackColor="Window">
<BorderDetails ColorTop="Window" ColorLeft="Window"></BorderDetails>

<Padding Left="3px"></Padding>
</RowStyleDefault>

<FilterOptionsDefault>
<FilterOperandDropDownStyle BorderWidth="1px" BorderColor="Silver" BorderStyle="Solid" Font-Size="11px" Font-Names="Verdana,Arial,Helvetica,sans-serif" BackColor="White" CustomRules="overflow:auto;">
<Padding Left="2px"></Padding>
</FilterOperandDropDownStyle>

<FilterHighlightRowStyle ForeColor="White" BackColor="#151C55"></FilterHighlightRowStyle>

<FilterDropDownStyle BorderWidth="1px" BorderColor="Silver" BorderStyle="Solid" Font-Size="11px" Font-Names="Verdana,Arial,Helvetica,sans-serif" BackColor="White" Width="200px" Height="300px" CustomRules="overflow:auto;">
<Padding Left="2px"></Padding>
</FilterDropDownStyle>
</FilterOptionsDefault>

<HeaderStyleDefault HorizontalAlign="Left" BorderStyle="Solid" BackColor="LightGray" CustomRules="font-weight:normal;">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</HeaderStyleDefault>

<EditCellStyleDefault BorderWidth="0px" BorderStyle="None"></EditCellStyleDefault>

<FrameStyle BorderWidth="1px" BorderColor="InactiveCaption" Font-Size="8.25pt" 
        Font-Names="Microsoft Sans Serif" BackColor="Window" Width="100%"></FrameStyle>

<Pager MinimumPagesForDisplay="2" AllowPaging="True">
<PagerStyle BorderWidth="1px" BorderStyle="Solid" BackColor="LightGray">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</PagerStyle>
</Pager>

<AddNewBox Hidden="False">
<BoxStyle BorderWidth="1px" BorderColor="InactiveCaption" BorderStyle="Solid" BackColor="Window">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</BoxStyle>
</AddNewBox>
</DisplayLayout>
</igtbl:ultrawebgrid>
            </TD></TR>
    </TBODY></TABLE>
</Template>

</asp:Content>

